For an empty table , this approach is significantly faster than creating the clustered index after importing the data , as it eliminates the sorting step 對于空表,此方法明顯快于導入數據后再創建聚集索引,因為它不需要執行排序。
To minimize blocking , you can specify a smaller batch size and use the order hint to eliminate the sorting step during the bulk import operation 為了盡可能減少阻塞,可以指定較小的批大小,并使用order提示去掉大容量導入操作中的排序步驟。